SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_SearchImageNews]

(
   @param_Title  Varchar(100)
)

AS
	/* SET NOCOUNT ON */
	SELECT  JOL_Bulletin_No,JOL_Bulletin_Title
	FROM dbo.JOL_Bulletin
	WHERE JOL_Bulletin_ImageUrl IS NOT NULL AND  JOL_Bulletin_ImageUrl<>'' AND  JOL_Bulletin_Title LIKE '%' + @param_Title + '%'
	ORDER BY JOL_Bulletin_UpdateTime,JOL_Bulletin_AddTime DESC
	
	RETURN
GO
